/*
 * Created on Feb 16, 2009
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package com.spring;


/**
 * @author Gopi
 * 
 *         TODO To change the template for this generated type comment go to
 *         Window - Preferences - Java - Code Style - Code Templates
 */
public interface SQLQueries {
	static final String SAVE_EXCEPTION_TRACE = "insert into `ExceptionTrace` (`exception`,`exceptionMessage`,`occuredDateTime`) values (:exception,:exceptionMessage,:occuredDateTime)";
	static final String SAVE_FORUM_DATA = "insert into `AlliBilliForum` (`name`,`content`,`postedDate`) values (:name,:content,:postedDate)";
	static final String SAVE_PLACE_MY_DATA = "insert into `placemyad` (`name`,`country`,`adTitle`,`gender`,`contactNumber`,`contactEmail`,`description`,`city`,`placedDate`,`state`) values (:name,:country,:adTitle,:gender,:contactNumber,:contactEmail,:description,:city,:placedDate,:state)";
	
	static final String LIST_FORUM_DATA = "SELECT * FROM AlliBilliForum A where A.content is not null and length(A.content)>0 order by A.postedDate desc";
	static final String LIST_PLACE_MY_DATA = "SELECT * FROM placemyad p";
	
	static final String COUNT_PLACE_MY_DATA = "SELECT count(1) FROM placemyad p";
	static final String COUNT_FORUM_DATA = "SELECT count(1) FROM AlliBilliForum";
	
}